/*
 Navicat MySQL Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : ali_user

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 09/07/2021 13:02:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for carts
-- ----------------------------
DROP TABLE IF EXISTS `carts`;
CREATE TABLE `carts` (
  `cId` int(10) NOT NULL AUTO_INCREMENT,
  `uId` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `cName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cPrice` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cNum` int(5) DEFAULT NULL,
  `cTotalPic` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cImg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cStatus` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  UNIQUE KEY `cId` (`cId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of carts
-- ----------------------------
BEGIN;
INSERT INTO `carts` VALUES (1, '4', 'NEW OPEN秋冬气质女神范温柔风轻奢名媛复古金丝绒唯美连衣裙3381', '95', 2, '190', '[{\"type\":\"S\",\"num\":\"1\"},{\"type\":\"M\",\"num\":\"1\"},{\"type\":\"定制L码\",\"num\":\"0\"}]', './images/shopImg/shop1.jpeg', '2021-07-09 12:Fr:06', '1');
COMMIT;

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `uID` int(5) NOT NULL AUTO_INCREMENT,
  `uName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `uPwd` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `uPhone` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `createdate` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  UNIQUE KEY `uName` (`uName`),
  UNIQUE KEY `uID` (`uID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
BEGIN;
INSERT INTO `userinfo` VALUES (1, 'wangqi', '123456', '17667571849', '2021-07-07', '1');
INSERT INTO `userinfo` VALUES (2, '2qeqe2', '111111', '13', '2021-07-08', '1');
INSERT INTO `userinfo` VALUES (3, '111111', '111111', '111111', '2021-07-08', '1');
INSERT INTO `userinfo` VALUES (4, 'zhangsan', '123456', '17667571849', '2021-07-09', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
